use ClientDW_A
db.CorporateData.updateMany({}, {$rename:{"CapitalIQID":"CapitalIqId"}})
db.CorporateData.update({},{ $unset: { SiblingsIds: "", CoverageIds: "" } },{ multi: true })
db.FinancialData.update({},{ $unset: { SiblingsIds: "", CoverageIds: "" } },{ multi: true })
db.CompanyKeyESGIssue.update({},{ $unset: { SiblingsIds: "", CoverageIds: "" } },{ multi: true })
use ClientDW_B
db.CorporateData.updateMany({}, {$rename:{"CapitalIQID":"CapitalIqId"}})
db.CorporateData.update({},{ $unset: { SiblingsIds: "", CoverageIds: "" } },{ multi: true })
db.FinancialData.update({},{ $unset: { SiblingsIds: "", CoverageIds: "" } },{ multi: true })
db.CompanyKeyESGIssue.update({},{ $unset: { SiblingsIds: "", CoverageIds: "" } },{ multi: true })